EMT Practice Test

1. Question Content...

---

Question1: A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table -
In-store Transactions -

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

Question2: An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

Question3: Consider this dataset showing the retirement age of 11 people, in whole years:
54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60
This tables show a simple frequency distribution of the retirement age data.

Question4: Given the following customer and order tables:
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Question5: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to BEST display the data?

Question6: What colors are commonly used for the change bars in a waterfall chart?

Question7: George is conducting a survey. He intends to distribute the survey via email and wants to optionally follow up with respondents based on their answers.
What quality dimension is most vital to the success of George's survey?
Choose the best answer.

Question8: A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.
Which of the following data manipulation techniques would he use to obtain this information?

Question9: How many variables are normally shown on a standard heat map?

Question10: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question11: A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?

Question12: Given the table below:

Which of the following variable types BEST describes the "Year" column?

Question13: Which dimension of data quality ensures that data stored in multiple locations is the same?

Question14: What output from a statistical test is used when performing hypothesis testing?

Question15: Which of the following is a process that is used during data integration to collect, blend, and load data?

Question16: What feature varies on a bubble chart but not on a scatter plot?

Question17: You are working with a dataset and need to swap the values in rows with those in columns.
What action do you need to perform?

Question18: An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

Question19: You only have one opportunity to answer each question on the Data+ exam.

Question20: What type of report is commonly used to make operational decisions?

Question21: When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.
What term describes this action?

Question22: Which of the following describes a programming language and free software environment for statistical computing and graphics?

Question23: You would like to combine the text in two different strings to form a single string.
What action are you performing?

Question24: A development company is constructing a new unit in its apartment complex. The complex has the following floor plans:

Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

Question25: What GAPP principle says that organizations should provide data subjects with the ability to review and update their personal information?

Question26: Which one of the following is NOT one of the five dimensions of data quality?

Question27: Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Question28: Which of the following contains alphanumeric values?

Question29: You are a database administrator and you create a precompiled query that is stored on the database server.
What have you created?

Question30: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question31: An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey that information?

Question32: The number of phone calls that call center receives in a day is an example of:

Question33: Encryption is a mechanism for protecting data.
When should encryption be applied to data?
Choose the best answer.

Question34: What R package makes it easy to work with dates?

Question35: While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Question36: Which of the following will MOST likely be streamed live?

Question37: Andrew conducts a study and wants to capture eye color.
What kind of data is eye color?
Choose the best response.

Question38: Which one of the following values would not be appropriately stored in integer data type?

Question39: Which of the following would be used to store unstructured data from different sources?

Question40: What is an example of data in transit?

Question41: An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?

Question42: Samantha needs to share a list of her organization's top 50 customers with the VP of sales.
She would like to include the name of the customer, the business they represent, their contact information, and their total sales over the past year.
The VP does not have any specialized analytics skills or software but would like to make some personal notes on the dataset.
What would be the best tool for Samantha to use to share this information?

Question43: Data validation should occur only when data is initially brought into a organization.

Question44: According to the empirical rule, what percent of thee values in a sample fall within three standard deviations of the mean in a normal distribution?

Question45: Harry is looking at home sales prices in single zip code and notices that one home sold for $940,394 when the average selling price of similar homes is $210,420.
What type of data does the $940,394 sales price represent?
Choose the best answer.

Question46: Zip code,____________, and___________ uniquely identify 87% of people in the United States.

Question47: Olivia has 15 people on her data analytics team. Her team's charter requires that all team members have read access to the finance, human resources, sales, and customer service areas of the corporate data warehouse.
What is the best way to provision access to her team?
Choose the best answer.

Question48: What is the final stage of the data lifecycle?

Question49: You would like to know whether the mean height of a group of children is statistically significantly different from that of another group.
What statistical test would be most appropriate?

Question50: What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?

Question51: Chris is building a database to store prices for items on a restaurant menu.
What data type is most appropriate for this field?

Question52: What's the minimum passing score on the Data+ exam?

Question53: When would you show time on a standard line chart?

Question54: What is the median of the following numbers?
13, 2, 65, 3, 5, 4, 7, 3, 4, 7, 8, 2, 4, 4, 60, 23, 43, 2

Question55: Which of the following is an example of a discrete variable?

Question56: What type of access permission system is most appropriate for a dashboard?

Question57: Five dogs have the following heights in millimeters:
300, 430, 170, 470, 600
Which of the following is the mean height for the five dogs?

Question58: An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Question59: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question60: James wants to analyze profit based on sales of five different product categories.
His source data set consists of 5.8 million rows with columns including region, product category, product name, and sales price.
How should he manipulate the data to facilitate his analysis?
Choose the best answer.

Question61: What term is used to describe an interactive visualization that encourages people to explore data dynamically?

Question62: Which one of the following is a common data warehouse schema?

Question63: What term indicates whether an attribute's value is within an expected range?

Question64: What effort has the goal of maintaining a single source of truth for the most important data elements handled by the organization?

Question65: What technique is used to swap the values in rows and columns of tabular data?

Question66: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question67: An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

Question68: Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

Question69: A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

Question70: Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average.
What should Andy's null hypothesis be?

Question71: Which of the following is a control measure for preventing a data breach?

Question72: What internal document explains privacy responsibilities to employees who will handle personally identifiable information?

Question73: Given the following graph:

Which of the following summary statements upholds integrity in data reporting?

Question74: Analytics reports should follow corporate style guidelines.

Question75: Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Question76: When building a word cloud, what feature varies with the frequency that a word appears in the text?

Question77: Analyze the values of X shown below
(2,2,5,6,7)
What is the range of these values?

Question78: You are creating a dashboard that shows the total revenue for your organization broken out by a variety of factors. Which one of these is a measure, rather than a dimension?